package com.wzdigit.wms.wms.mapper.inv.count;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wzdigit.framework.orm.mybatis.MyBatisRepository;
import com.wzdigit.wms.wms.client.response.inv.count.CoutnScopeRespnse;
import com.wzdigit.wms.wms.domain.inv.count.InvCountScope;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 
 * @since 2021-10-08
 */

@MyBatisRepository
public interface InvCountScopeMapper extends BaseMapper<InvCountScope> {

    //CLOB字段查询慢，因此用这个方法
/*    List<InvCountScope> selectAll(@Param("headerId") BigDecimal headerId);*/

    //盘点范围报表
    List<CoutnScopeRespnse> selectReport(@Param("headerId") BigDecimal headerId);

    //查询盘点范围
    List<InvCountScope> selectScopes(@Param("zoneStr") String zoneStr,@Param("locStr") String locStr,
                                         @Param("lotnoStr") String lotnoStr,@Param("cateStr") String cateStr,
                                     @Param("skuStr") String skuStr,@Param("headerId") BigDecimal headerId);

    List<InvCountScope> selectAllScopes(@Param("loc") String loc,@Param("sku") String sku);
}
